--
-- Agregado de un nuevo reporte general para las etiquetas de padrón
--

INSERT INTO public.repgral(
	nombre, id, template, accesousuarios, idambdb, fechainsert, fechaupdate, accesosucursales)
	VALUES ('Listado de etiquetas de padron', 120, 
'object rpListadoEtiquetas: TppReport
  AutoStop = False
  Columns = 2
  ColumnPositions.Strings = (
    ''0''
    ''105000'')
  DataPipeline = plListadoEtiquetas
  PrinterSetup.BinName = ''Default''
  PrinterSetup.Collation = False
  PrinterSetup.DocumentName = ''Reportes''
  PrinterSetup.PaperName = ''A4''
  PrinterSetup.PrinterName = ''Default''
  PrinterSetup.mmMarginBottom = 0
  PrinterSetup.mmMarginLeft = 0
  PrinterSetup.mmMarginRight = 0
  PrinterSetup.mmMarginTop = 0
  PrinterSetup.mmPaperHeight = 297000
  PrinterSetup.mmPaperWidth = 210000
  PrinterSetup.PaperSize = 9
  SaveAsTemplate = True
  Template.DatabaseSettings.DataPipeline = plReportes
  Template.DatabaseSettings.Name = ''Listado de etiquetas de padron''
  Template.DatabaseSettings.NameField = ''nombre''
  Template.DatabaseSettings.TemplateField = ''template''
  Template.SaveTo = stDatabase
  Template.Format = ftASCII
  Units = utMillimeters
  DeviceType = ''Screen''
  OnPreviewFormCreate = GcoPreviewFormCreate
  OutlineSettings.CreateNode = True
  OutlineSettings.CreatePageNodes = True
  OutlineSettings.Enabled = False
  PreviewFormSettings.WindowState = wsMaximized
  PreviewFormSettings.ZoomSetting = zsPercentage
  Left = 152
  Top = 80
  Version = ''7.0''
  mmColumnWidth = 105000
  DataPipelineName = ''plListadoEtiquetas''
  object ppColumnHeaderBand1: TppColumnHeaderBand
    mmBottomOffset = 0
    mmHeight = 0
    mmPrintPosition = 0
  end
  object ppDetailBand1: TppDetailBand
    BeforePrint = GcoBandBeforePrint
    mmBottomOffset = 2000
    mmHeight = 32279
    mmPrintPosition = 0
    object ppDBText1: TppDBText
      UserName = ''DBText1''
      DataField = ''Nombre''
      DataPipeline = plListadoEtiquetas
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      Transparent = True
      DataPipelineName = ''plListadoEtiquetas''
      mmHeight = 4233
      mmLeft = 3969
      mmTop = 1852
      mmWidth = 94986
      BandType = 4
    end
    object ppDBText2: TppDBText
      UserName = ''DBText2''
      DataField = ''Domicilio''
      DataPipeline = plListadoEtiquetas
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      Transparent = True
      DataPipelineName = ''plListadoEtiquetas''
      mmHeight = 3969
      mmLeft = 3969
      mmTop = 7408
      mmWidth = 94721
      BandType = 4
    end
    object ppDBText3: TppDBText
      UserName = ''DBText3''
      DataField = ''Ciudad''
      DataPipeline = plListadoEtiquetas
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      Transparent = True
      DataPipelineName = ''plListadoEtiquetas''
      mmHeight = 3969
      mmLeft = 3969
      mmTop = 12965
      mmWidth = 60061
      BandType = 4
    end
    object ppDBText4: TppDBText
      UserName = ''DBText4''
      DataField = ''Provincia''
      DataPipeline = plListadoEtiquetas
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      Transparent = True
      DataPipelineName = ''plListadoEtiquetas''
      mmHeight = 3969
      mmLeft = 3969
      mmTop = 19050
      mmWidth = 59796
      BandType = 4
    end
    object ppDBText5: TppDBText
      UserName = ''DBText5''
      DataField = ''Libre''
      DataPipeline = plListadoEtiquetas
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Name = ''Arial''
      Font.Size = 10
      Font.Style = []
      Transparent = True
      DataPipelineName = ''plListadoEtiquetas''
      mmHeight = 4763
      mmLeft = 3704
      mmTop = 26988
      mmWidth = 94986
      BandType = 4
    end
  end
  object ppColumnFooterBand1: TppColumnFooterBand
    mmBottomOffset = 0
    mmHeight = 0
    mmPrintPosition = 0
  end
end
', '*', NULL, NOW(), NULL, '*');

--   
SELECT aaversion('515.01','515.00');
--    


